Group Aggregate Functoid
Description: The Group Aggregate Functoid groups data within a dataset (usually a table) according to the input on GroupBy. Instances belonging to each group are represented by the Value input. Consider the examples for more clarity.
Inputs with their allowed values:
- Value
- Literal text entered manually
- Output of another Functoid
- Value of a Table
- GroupBy
_Group-aggregate.png)
Picture of the Group Aggregate Functoid
Remark: General: The Group Aggregate Functoid is mostly only useful when combined with any other aggregate Functoid. The output (when the Show box is ticked on) from the Group Aggregate Functoid will seem identical to the Value field when looking in the Result Pane. Other Aggregate Functoids are used to show/manipulate the entire set of data. GroupBy: Please note that while physically it is possible to manually enter a GroupBy value, this will not contribute to the purpose of the Group functoid since data needs to be instanced per record in a table connected.
Example: For our example we will be considering the following source table contents, which more or less is a simple list of transactions specifying the amount involved and through which medium or method the transaction has taken place:
See Figure 1.
_Group-aggregate-example.png)
Figure 1
If we now would need summary information per type of transaction, like totals, averages or any other available aggregates we need to use the Group Aggregate Functoid to group on TxType and send through the corresponding values we want to calculate or aggregate on which in this case would be the TxAmount column. In the following solution overview we have set up a calculation of total amount per transactiontype and a number of transaction per transactiontype. Be sure to enable (while in the diagram) the Properties>Destinct>Output option by ticking the box. After Importing (No) and clicking View Last again the following result should show:
See Figure 2.
_Group-aggregate-example-2.png)
Figure 2